package com.jy.adscm.operation.cgxsb.mapper.mysql;

import com.jy.adscm.operation.cgxsb.bean.CgUser;
import com.jy.adscm.operation.cgxsb.bean.CgxsTaskinfo;
import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.jy.adscm.operation.cgxsb.bean.khxx;
import com.jy.adscm.operation.cgxsb.bean.spmc;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author yyy
 * @since 2019-01-10
 */
public interface CgxsTaskinfoMapper extends BaseMapper<CgxsTaskinfo> {

    List<CgxsTaskinfo> queryByRwlx(@Param("rwlx")String rwlx,@Param("rwzt")String rwzt,@Param("rwwczt")String rwwczt,@Param("key")String key);

    List<khxx> queryByKhxx(@Param("type")String type);

    List<CgUser> queryByYY(@Param("roleid") String roleid);
    @Select("SELECT MAX(ORDERNUMS) FROM base_taskinfo WHERE FBSJ LIKE NOW()")
    String queryOrderNums();
}
